home *** CD-ROM | disk | FTP | other *** search
/ InterCD 2001 January / january_2001.iso / intercd / root / ^4Developers / VB / visbasdb / VBDB / VBDB Code / VB5 Code / Class 6 / Example6-2.frm (.txt) < prev    next >
Encoding:
Visual Basic Form  |  1999-09-18  |  5.1 KB  |  171 lines
  1. VERSION 5.00
  2. Begin VB.Form frmAuthors 
  3.    BorderStyle     =   1  'Fixed Single
  4.    Caption         =   "Authors"
  5.    ClientHeight    =   2625
  6.    ClientLeft      =   45
  7.    ClientTop       =   330
  8.    ClientWidth     =   4680
  9.    LinkTopic       =   "Form1"
  10.    MaxButton       =   0   'False
  11.    MinButton       =   0   'False
  12.    ScaleHeight     =   2625
  13.    ScaleWidth      =   4680
  14.    StartUpPosition =   3  'Windows Default
  15.    Begin VB.Data datAuthors 
  16.       Caption         =   "Data1"
  17.       Connect         =   "Access"
  18.       DatabaseName    =   "c:\VBDB\Working\Biblio.mdb"
  19.       DefaultCursorType=   0  'DefaultCursor
  20.       DefaultType     =   2  'UseODBC
  21.       Exclusive       =   0   'False
  22.       Height          =   300
  23.       Left            =   2520
  24.       Options         =   0
  25.       ReadOnly        =   0   'False
  26.       RecordsetType   =   1  'Dynaset
  27.       RecordSource    =   "SELECT * FROM Authors ORDER BY Author"
  28.       Top             =   120
  29.       Visible         =   0   'False
  30.       Width           =   1980
  31.    End
  32.    Begin VB.CommandButton cmdDone 
  33.       Caption         =   "Do&ne"
  34.       Height          =   375
  35.       Left            =   3240
  36.       TabIndex        =   13
  37.       Top             =   2160
  38.       Width           =   1215
  39.    End
  40.    Begin VB.CommandButton cmdDelete 
  41.       Caption         =   "&Delete"
  42.       Height          =   375
  43.       Left            =   1680
  44.       TabIndex        =   12
  45.       Top             =   2160
  46.       Width           =   1215
  47.    End
  48.    Begin VB.CommandButton cmdEdit 
  49.       Caption         =   "&Edit"
  50.       Height          =   375
  51.       Left            =   120
  52.       TabIndex        =   11
  53.       Top             =   1680
  54.       Width           =   1215
  55.    End
  56.    Begin VB.CommandButton cmdCancel 
  57.       Caption         =   "&Cancel"
  58.       Height          =   375
  59.       Left            =   3240
  60.       TabIndex        =   10
  61.       Top             =   1680
  62.       Width           =   1215
  63.    End
  64.    Begin VB.CommandButton cmdSave 
  65.       Caption         =   "&Save"
  66.       Height          =   375
  67.       Left            =   1680
  68.       TabIndex        =   9
  69.       Top             =   1680
  70.       Width           =   1215
  71.    End
  72.    Begin VB.CommandButton cmdAddNew 
  73.       Caption         =   "&Add New"
  74.       Height          =   375
  75.       Left            =   120
  76.       TabIndex        =   8
  77.       Top             =   2160
  78.       Width           =   1215
  79.    End
  80.    Begin VB.CommandButton cmdNext 
  81.       Caption         =   "Next =>"
  82.       Height          =   255
  83.       Left            =   2520
  84.       TabIndex        =   7
  85.       Top             =   1320
  86.       Width           =   1215
  87.    End
  88.    Begin VB.CommandButton cmdPrevious 
  89.       Caption         =   "<= Previous"
  90.       Height          =   255
  91.       Left            =   1080
  92.       TabIndex        =   6
  93.       Top             =   1320
  94.       Width           =   1215
  95.    End
  96.    Begin VB.TextBox txtYearBorn 
  97.       DataField       =   "Year Born"
  98.       DataSource      =   "datAuthors"
  99.       Height          =   285
  100.       Left            =   1200
  101.       Locked          =   -1  'True
  102.       TabIndex        =   3
  103.       Text            =   "Text3"
  104.       Top             =   840
  105.       Width           =   1215
  106.    End
  107.    Begin VB.TextBox txtAuthor 
  108.       DataField       =   "Author"
  109.       DataSource      =   "datAuthors"
  110.       Height          =   285
  111.       Left            =   1200
  112.       Locked          =   -1  'True
  113.       TabIndex        =   2
  114.       Text            =   "Text2"
  115.       Top             =   480
  116.       Width           =   3375
  117.    End
  118.    Begin VB.TextBox txtAuthorID 
  119.       DataField       =   "Au_ID"
  120.       DataSource      =   "datAuthors"
  121.       Height          =   285
  122.       Left            =   1200
  123.       Locked          =   -1  'True
  124.       TabIndex        =   1
  125.       Text            =   "Text1"
  126.       Top             =   120
  127.       Width           =   1215
  128.    End
  129.    Begin VB.Label Label3 
  130.       Caption         =   "Year Born"
  131.       Height          =   255
  132.       Left            =   120
  133.       TabIndex        =   5
  134.       Top             =   840
  135.       Width           =   1215
  136.    End
  137.    Begin VB.Label Label2 
  138.       Caption         =   "Author Name"
  139.       Height          =   255
  140.       Left            =   120
  141.       TabIndex        =   4
  142.       Top             =   480
  143.       Width           =   1215
  144.    End
  145.    Begin VB.Label Label1 
  146.       Caption         =   "Author ID"
  147.       Height          =   255
  148.       Left            =   120
  149.       TabIndex        =   0
  150.       Top             =   120
  151.       Width           =   1215
  152.    End
  153. Attribute VB_Name = "frmAuthors"
  154. Attribute VB_GlobalNameSpace = False
  155. Attribute VB_Creatable = False
  156. Attribute VB_PredeclaredId = True
  157. Attribute VB_Exposed = False
  158. Option Explicit
  159. Private Sub cmdNext_Click()
  160. datAuthors.Recordset.MoveNext
  161. If datAuthors.Recordset.EOF Then
  162.   datAuthors.Recordset.MoveLast
  163. End If
  164. End Sub
  165. Private Sub cmdPrevious_Click()
  166. datAuthors.Recordset.MovePrevious
  167. If datAuthors.Recordset.BOF Then
  168.   datAuthors.Recordset.MoveFirst
  169. End If
  170. End Sub
  171.